SELECT * FROM (SELECT t.param, tl.value, tl.id_page, tl.id_translate, (IF(tl.id_period=0, 1000, (SELECT id_position FROM wct_period WHERE tid=tl.id_period))) AS id_position FROM wct_translate AS t, wct_translate_language AS tl WHERE t.visible='1' AND t.tid=tl.id_translate AND tl.id_language='1' AND tl.id_page IN (0, '220') AND tl.id_app IN (1,0) AND tl.id_period IN (0) AND tl.value!='' ORDER BY id_page DESC, id_app DESC, id_position ASC) AS selection GROUP BY id_translate: Disk full (/tmp/#sql_4a8_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")